const mysql = require('mysql');
const {
	MYSQL_CONF
} = require('../conf/db.js')

const con = mysql.createConnection(MYSQL_CONF)

con.connect()

function exec(sql) {
	const promise = new Promise((resolve,reject)=>{
		con.query(sql, (err, result) => {
			if(err){console.log('mysql_err'+err);return}
			resolve(result)
		})
	})
	return promise
}
module.exports = {
	exec,
	escape:mysql.escape
}